Parameters Provided:
name.synonym = BTS 54524; BTS-54524; C17H26ClN; Cyclobutanemethanamine, 1-(4-chlorophenyl)-N,N-dimethyl-alpha-(2-methylpropyl)-; DEA No. 1675; LS-172014; Medaria; Meridia; N-1-(1-(4-chlorophenyl)cyclobutyl)-3-methylbutyl-N,N-dimethylamine HCl; Reductil; Sibutramina [Spa
filter.purchasability = all
page.num = 1
Structural Results Found: (before additional filtering)
SQL Query Was
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE 'BTS 54524; BTS-54524; C17H26ClN; Cyclobutanemethanamine, 1-(4-chlorophenyl)-N,N-dimethyl-alpha-(2-methylpropyl)-; DEA No. 1675; LS-172014; Medaria; Meridia; N-1-(1-(4-chlorophenyl)cyclobutyl)-3-methylbutyl-N,N-dimethylamine HCl; Reductil; Sibutramina [Spa' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 ) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?name.synonym=BTS+54524%3B+BTS-54524%3B+C17H26ClN%3B+Cyclobutanemethanamine%2C+1-%284-chlorophenyl%29-N%2CN-dimethyl-alpha-%282-methylpropyl%29-%3B+DEA+No.+1675%3B+LS-172014%3B+Medaria%3B+Meridia%3B+N-1-%281-%284-chlorophenyl%29cyclobutyl%29-3-methylbutyl-N%2CN-dimethylamine+HCl%3B+Reductil%3B+Sibutramina+%5BSpa&filter.purchasability=all
Embed Link to Results
